File:product-2.html
Method:query.scalar(columns,*where,*order)
语法错误 (操作符丢失) 在查询表达式 'ProductId=' 中。
select top 1 ProductName FROM cpproduct WHERE ProductId=
数据库执行错误
xmls/product.xmls
...];
@querygproduct[TagIds]=[",2,"];
@tablect=@querygproduct.table(*,['CatalogId={*CatalogId} and TagIds like {#like(%TagIds%)} '],['Grade desc,ProductId asc']);
@listtb=@tablect.format(@format1);
}
$return(@listta);
}
$sub listProduct(){
@querycon=$query(image,product);
@querypro=$query(product,product);
@id=$http.get(pid,$null);
$if(@id==$null){
$write(['<script>history.back(-1);</script>']);
$end();
}
@querycon[ProductId]=@id;
@querypro[ProductId]=@id;
@Piclist=$string();
@productName=@querypro.scalar(['ProductName'],['ProductId={*ProductId}']);
@tablegs=@querycon.table(['ImageId,ProductId,Thumbnail,Pic'],['ProductId={*ProductId}'],['Grade desc,ImageId asc']);
@Thumlist=@tablegs.format([#<li class="pull-left"><span class="dis"><img class="maxwh" src="{*Thumbnail}"></span></li>#]){
@Piclist.append(["<li class="pull-left"><img src="{$var[Pic]}" ></li>"]);
};
$return($empty);
}
//产品属性
$function listAttribute(format,format1){
@querycata=$query(catalog...